Create or delete custom views

Before you create a view Set up the workbook to appear the way you want to view and print it. If you include print settings in a view, the view includes the defined print area, or the entire worksheet if the sheet has no defined print area.

Change the settings that you want to save in the view.
On the View menu, click Custom Views.
Click Add.
In the Name box, type a name for the view.
Make sure to include the active sheet name in the name of a view to make it easier to identify. When you display a view, Microsoft Excel switches to the sheet that was active when you created the view. Excel lists all views in the workbook in the Custom Views dialog box.
Under Include in view, select the options you want.

On the View menu, click Custom Views.
In the Views box, click the name of the view you want, and then click Delete.